| 300 |
How do I change the cell's foreground color
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("C1") oG2antt.Columns.Add("C2") var_Items = oG2antt.Items h = var_Items.AddItem("Cell 1") ' var_Items.CellValue(h,1) = "Cell 2" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = `Cell 2`" ' var_Items.CellForeColor(h,1) = 255 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellForeColor(h,1) = 255" |
| 299 |
How do I change the visual effect for the cell, using your EBN files
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") oG2antt.Columns.Add("C1") oG2antt.Columns.Add("C2") var_Items = oG2antt.Items h = var_Items.AddItem("Cell 1") ' var_Items.CellValue(h,1) = "Cell 2" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = `Cell 2`" ' var_Items.CellBackColor(h,1) = 16777216 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellBackColor(h,1) = 16777216" |
| 298 |
How do I change the cell's background color
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("C1") oG2antt.Columns.Add("C2") var_Items = oG2antt.Items h = var_Items.AddItem("Cell 1") ' var_Items.CellValue(h,1) = "Cell 2" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = `Cell 2`" ' var_Items.CellBackColor(h,1) = 255 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellBackColor(h,1) = 255" |
| 297 |
How do I change the caption or value for a particular cell
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("C1") oG2antt.Columns.Add("C2") var_Items = oG2antt.Items ' var_Items.CellValue(var_Items.AddItem("Cell 1"),1) = "Cell 2" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(AddItem(`Cell 1`),1) = `Cell 2`" |
| 296 |
How do I get the handle of the cell
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items h = var_Items.AddItem("Root 1") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" ' var_Items.CellBold(,var_Items.ItemCell(h,0)) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellBold(,ItemCell(h,0)) = True" |
| 295 |
How do I retrieve the focused item
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items h = var_Items.AddItem("Root 1") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" ' var_Items.ItemBold(var_Items.FocusItem) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBold(FocusItem) = True" |
| 294 |
How do I get the number or count of child items
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items h = var_Items.AddItem("Root 1") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" var_Items.AddItem(var_Items.ChildCount(h)) |
| 293 |
How do I enumerate the visible items
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items h = var_Items.AddItem("Root 1") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" h = var_Items.AddItem("Root 2") ' var_Items.ItemBold(var_Items.FirstVisibleItem) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBold(FirstVisibleItem) = True" ' var_Items.ItemBold(var_Items.NextVisibleItem(var_Items.FirstVisibleItem)) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBold(NextVisibleItem(FirstVisibleItem)) = True" |
| 292 |
How do I enumerate the siblings items
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items h = var_Items.AddItem("Root 1") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" h = var_Items.AddItem("Root 2") ' var_Items.ItemBold(var_Items.NextSiblingItem(var_Items.FirstVisibleItem)) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBold(NextSiblingItem(FirstVisibleItem)) = True" ' var_Items.ItemBold(var_Items.PrevSiblingItem(var_Items.NextSiblingItem(var_Items.FirstVisibleItem))) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBold(PrevSiblingItem(NextSiblingItem(FirstVisibleItem))) = True" |
| 291 |
How do I get the parent item
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items h = var_Items.AddItem("Root 1") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" ' var_Items.ItemBold(var_Items.ItemParent(var_Items.ItemChild(h))) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBold(ItemParent(ItemChild(h))) = True" |
| 290 |
How do I get the first child item
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items h = var_Items.AddItem("Root 1") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" ' var_Items.ItemBold(var_Items.ItemChild(h)) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBold(ItemChild(h)) = True" |
| 289 |
How do I enumerate the root items
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items h = var_Items.AddItem("Root 1") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" h = var_Items.AddItem("Root 2") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") ' var_Items.ItemBold(var_Items.RootItem(0)) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBold(RootItem(0)) = True" ' var_Items.ItemUnderline(var_Items.RootItem(1)) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemUnderline(RootItem(1)) = True" |
| 288 |
I have a hierarchy, how can I count the number of root items
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items h = var_Items.AddItem("Root 1") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" h = var_Items.AddItem("Root 2") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") var_Items.AddItem(var_Items.RootCount) |
| 287 |
How can I make an item unselectable, or not selectable
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Column") var_Items = oG2antt.Items h = var_Items.AddItem("unselectable - you can't get selected") ' var_Items.SelectableItem(h) = .f. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.SelectableItem(h) = False" var_Items.AddItem("selectable") |
| 286 |
How can I hide or show an item
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Column") var_Items = oG2antt.Items h = var_Items.AddItem("hidden") ' var_Items.ItemHeight(h) = 0 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemHeight(h) = 0" ' var_Items.SelectableItem(h) = .f. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.SelectableItem(h) = False" var_Items.AddItem("visible") |
| 285 |
How can I change the height for all items
Dim oG2antt as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.DefaultItemHeight = 32 oG2antt.Columns.Add("Column") oG2antt.Items.AddItem("One") oG2antt.Items.AddItem("Two") |
| 284 |
How do I change the height of an item
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.ScrollBySingleLine = .t. oG2antt.Columns.Add("Default") var_Items = oG2antt.Items ' var_Items.ItemHeight(var_Items.AddItem("height")) = 128 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemHeight(AddItem(`height`)) = 128" oG2antt.Items.AddItem("enabled") |
| 283 |
How do I disable or enable an item
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items ' var_Items.EnableItem(var_Items.AddItem("disabled")) = .f. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.EnableItem(AddItem(`disabled`)) = False" oG2antt.Items.AddItem("enabled") |
| 282 |
How do I display as strikeout a cell
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items ' var_Items.CellStrikeOut(var_Items.AddItem("strikeout"),0) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellStrikeOut(AddItem(`strikeout`),0) = True" |
| 281 |
How do I display as strikeout a cell or an item
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items ' var_Items.CellValueFormat(var_Items.AddItem("gets <s>strikeout</s> only a portion of text"),0) = 1 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValueFormat(AddItem(`gets <s>strikeout</s> only a portion of text`),0) = 1" |
| 280 |
How do I display as strikeout an item
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items ' var_Items.ItemStrikeOut(var_Items.AddItem("strikeout")) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemStrikeOut(AddItem(`strikeout`)) = True" |
| 279 |
How do I underline a cell
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items ' var_Items.CellUnderline(var_Items.AddItem("underline"),0) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellUnderline(AddItem(`underline`),0) = True" |
| 278 |
How do I underline a cell or an item
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items ' var_Items.CellValueFormat(var_Items.AddItem("gets <u>underline</u> only a portion of text"),0) = 1 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValueFormat(AddItem(`gets <u>underline</u> only a portion of text`),0) = 1" |
| 277 |
How do I underline an item
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items ' var_Items.ItemUnderline(var_Items.AddItem("underline")) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemUnderline(AddItem(`underline`)) = True" |
| 276 |
How do I display as italic a cell
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items ' var_Items.CellItalic(var_Items.AddItem("italic"),0) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellItalic(AddItem(`italic`),0) = True" |
| 275 |
How do I display as italic a cell or an item
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items ' var_Items.CellValueFormat(var_Items.AddItem("gets <i>italic</i> only a portion of text"),0) = 1 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValueFormat(AddItem(`gets <i>italic</i> only a portion of text`),0) = 1" |
| 274 |
How do I display as italic an item
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items ' var_Items.ItemItalic(var_Items.AddItem("italic")) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemItalic(AddItem(`italic`)) = True" |
| 273 |
How do I bold a cell
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items ' var_Items.CellBold(var_Items.AddItem("bold"),0) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellBold(AddItem(`bold`),0) = True" |
| 272 |
How do I bold a cell or an item
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items ' var_Items.CellValueFormat(var_Items.AddItem("gets <b>bold</b> only a portion of text"),0) = 1 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValueFormat(AddItem(`gets <b>bold</b> only a portion of text`),0) = 1" |
| 271 |
How do I bold an item
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items ' var_Items.ItemBold(var_Items.AddItem("bold")) = .t. oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemBold(AddItem(`bold`)) = True" |
| 270 |
How do I change the foreground color for the item
Dim h as N Dim hC as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items h = var_Items.AddItem("Root") hC = var_Items.InsertItem(h,,"Child 1") ' var_Items.ItemForeColor(hC) = 255 oG2antt.TemplateDef = "dim var_Items,hC" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = hC oG2antt.Template = "var_Items.ItemForeColor(hC) = 255" var_Items.InsertItem(h,,"Child 2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" |
| 269 |
How do I change the visual appearance for the item, using your EBN technology
|
| 268 |
How do I change the background color for the item
Dim h as N Dim hC as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items h = var_Items.AddItem("Root") hC = var_Items.InsertItem(h,,"Child 1") ' var_Items.ItemBackColor(hC) = 255 oG2antt.TemplateDef = "dim var_Items,hC" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = hC oG2antt.Template = "var_Items.ItemBackColor(hC) = 255" var_Items.InsertItem(h,,"Child 2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" |
| 267 |
How do I expand or collapse an item
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items h = var_Items.AddItem("Root") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" |
| 266 |
How do I associate an extra data to an item
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items ' var_Items.ItemData(var_Items.AddItem("item")) = "your extra data" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemData(AddItem(`item`)) = `your extra data`" |
| 265 |
How do I get the number or count of items
Dim h as N Dim oG2antt as P Dim var_Items as P Dim var_Items1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items h = var_Items.AddItem("Root") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" var_Items1 = oG2antt.Items var_Items1.AddItem(var_Items1.ItemCount) |
| 264 |
How can I specify the width of the ActiveX control, when using the InsertControlItem property
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.ScrollBySingleLine = .f. oG2antt.TreeColumnIndex = 1 oG2antt.DrawGridLines = -1 oG2antt.Columns.Add("C1") oG2antt.Columns.Add("C2") oG2antt.Columns.Add("C3") var_Items = oG2antt.Items h = var_Items.InsertControlItem(,"MSCAL.Calendar") ' var_Items.ItemWidth(h) = 128 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemWidth(h) = 128" ' var_Items.CellValue(h,0) = "This is a bit of text that is shown in the first column" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,0) = `This is a bit of text that is shown in the first column`" ' var_Items.CellSingleLine(h,0) = .f. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellSingleLine(h,0) = False" ' var_Items.CellValue(h,2) = "This is a bit of text that is shown in the third column" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,2) = `This is a bit of text that is shown in the third column`" ' var_Items.CellSingleLine(h,2) = .f. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellSingleLine(h,2) = False" |
| 263 |
How can I put the ActiveX control in a different column, when using the InsertControlItem property
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.ScrollBySingleLine = .f. oG2antt.DrawGridLines = -1 oG2antt.Columns.Add("C1") oG2antt.Columns.Add("C2") oG2antt.Columns.Add("C3") var_Items = oG2antt.Items h = var_Items.InsertControlItem(,"MSCAL.Calendar") ' var_Items.CellValue(h,0) = "This is a bit of text that is shown in the first column" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,0) = `This is a bit of text that is shown in the first column`" ' var_Items.CellSingleLine(h,0) = .f. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellSingleLine(h,0) = False" ' var_Items.ItemWidth(h) = -32001 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemWidth(h) = -32001" ' var_Items.CellValue(h,2) = "This is a bit of text that is shown in the third column" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,2) = `This is a bit of text that is shown in the third column`" ' var_Items.CellSingleLine(h,2) = .f. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellSingleLine(h,2) = False" |
| 262 |
Is there any function I can use to get the program or the control identifier I've been using when called the InsertControlItem
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") oG2antt.ScrollBySingleLine = .f. oG2antt.LinesAtRoot = -1 var_Items = oG2antt.Items h = var_Items.InsertControlItem(,"MSCAL.Calendar") var_Items.InsertItem(h,,var_Items.ItemControlID(h)) ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" h = var_Items.InsertControlItem(,"MSChart20Lib.MSChart") ' var_Items.ItemAppearance(h) = 4 oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ItemAppearance(h) = 4" var_Items.InsertItem(h,,var_Items.ItemControlID(h)) ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" |
| 261 |
How can I change the height of newly created ActiveX control, using the InsertControlItem
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") oG2antt.ScrollBySingleLine = .f. var_Items = oG2antt.Items ' var_Items.ItemHeight(var_Items.InsertControlItem(,"MSCAL.Calendar")) = 64 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemHeight(InsertControlItem(,`MSCAL.Calendar`)) = 64" ' var_Items.ItemAppearance(var_Items.InsertControlItem(,"MSChart20Lib.MSChart")) = 4 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemAppearance(InsertControlItem(,`MSChart20Lib.MSChart`)) = 4" |
| 260 |
How can I change the border for newly created ActiveX control, using the InsertControlItem
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") oG2antt.ScrollBySingleLine = .f. var_Items = oG2antt.Items ' var_Items.ItemAppearance(var_Items.InsertControlItem(,"MSCAL.Calendar")) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemAppearance(InsertControlItem(,`MSCAL.Calendar`)) = 2" ' var_Items.ItemAppearance(var_Items.InsertControlItem(,"MSChart20Lib.MSChart")) = 4 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.ItemAppearance(InsertControlItem(,`MSChart20Lib.MSChart`)) = 4" |
| 259 |
How can I access the properties and methods for an ActiveX control that I've just added using the InsertControlItem
Dim h as N Dim oG2antt as P Dim var_Calendar as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items h = var_Items.AddItem("Root") var_Calendar = var_Items.ItemObject(var_Items.InsertControlItem(h,"MSCAL.Calendar")) var_Calendar.BackColor = 16777215 var_Calendar.GridCellEffect = 0 var_Calendar.ShowTitle = .f. var_Calendar.ShowDateSelectors = .f. ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" |
| 258 |
How can I access the properties and methods for an ActiveX control that I've just added using the InsertControlItem
Dim h as N Dim oG2antt as P Dim var_Calendar as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items h = var_Items.AddItem("Root") var_Calendar = var_Items.ItemObject(var_Items.InsertControlItem(h,"MSCAL.Calendar")) var_Calendar.BackColor = 16777215 ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" |
| 257 |
How can I insert an ActiveX control
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items h = var_Items.AddItem("Root") var_Items.InsertControlItem(h,"MSCAL.Calendar") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" |
| 256 |
How can I change at runtime the parent of the item
Dim hC as N Dim hP as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.LinesAtRoot = -1 oG2antt.Columns.Add("Default") var_Items = oG2antt.Items hP = var_Items.AddItem("Root") hC = var_Items.AddItem("Child") var_Items.SetParent(hC,hP) |
| 255 |
How can I sort the items
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items h = var_Items.AddItem("Root") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" oG2antt.Columns.Item("Default").SortOrder = 2 |
| 254 |
How do I sort the child items
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") var_Items = oG2antt.Items h = var_Items.AddItem("Root") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" var_Items.SortChildren(h,0,.f.) |
| 253 |
How can I ensure or scroll the control so the item fits the control's client area
Dim h as N Dim oG2antt as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") h = oG2antt.Items.AddItem("item") oG2antt.Items.EnsureVisibleItem(h) |
| 252 |
How can I remove or delete all items
Dim oG2antt as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") oG2antt.Items.AddItem("removed item") oG2antt.Items.RemoveAllItems() |
| 251 |
How can I remove or delete an item
Dim h as N Dim oG2antt as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") h = oG2antt.Items.AddItem("removed item") oG2antt.Items.RemoveItem(h) |
| 250 |
How can I add or insert child items
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.LinesAtRoot = -1 oG2antt.Columns.Add("C1") oG2antt.Columns.Add("C2") var_Items = oG2antt.Items h = var_Items.AddItem("Cell 1") ' var_Items.CellValue(h,1) = "Cell 2" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = `Cell 2`" ' var_Items.CellValue(var_Items.InsertItem(h,,"Cell 3"),1) = "Cell 4" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(InsertItem(h,,`Cell 3`),1) = `Cell 4`" ' var_Items.CellValue(var_Items.InsertItem(h,,"Cell 5"),1) = "Cell 6" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(InsertItem(h,,`Cell 5`),1) = `Cell 6`" ' var_Items.ExpandItem(h) = .t. oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.ExpandItem(h) = True" |
| 249 |
How can I add or insert a child item
Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.LinesAtRoot = -1 oG2antt.Columns.Add("Default") var_Items = oG2antt.Items var_Items.InsertItem(var_Items.AddItem("root"),,"child") |
| 248 |
How can I add or insert an item
Dim h as N Dim oG2antt as P Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("C1") oG2antt.Columns.Add("C2") var_Items = oG2antt.Items ' var_Items.CellValue(var_Items.AddItem("Cell 1"),1) = "Cell 2" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(AddItem(`Cell 1`),1) = `Cell 2`" h = var_Items.AddItem("Cell 3") ' var_Items.CellValue(h,1) = "Cell 4" oG2antt.TemplateDef = "dim var_Items,h" oG2antt.TemplateDef = var_Items oG2antt.TemplateDef = h oG2antt.Template = "var_Items.CellValue(h,1) = `Cell 4`" |
| 247 |
How can I add or insert an item
Dim oG2antt as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("Default") oG2antt.Items.AddItem("new item") |
| 246 |
How can I get the columns as they are shown in the control's sortbar
Dim oG2antt as P Dim var_Object as P oG2antt = topparent:CONTROL_ACTIVEX1.activex var_Object = oG2antt.Columns.ItemBySortPosition(0) |
| 245 |
How can I access the properties of a column
Dim oG2antt as P Dim var_Column as local oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("A") ' oG2antt.Columns.Item("A").HeaderBold = .t. var_Column = oG2antt.Columns.Item("A") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.HeaderBold = True" |
| 244 |
How can I remove all the columns
Dim oG2antt as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Clear() |
| 243 |
How can I remove a column
Dim oG2antt as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Remove("A") |
| 242 |
How can I get the number or the count of columns
Dim oG2antt as P Dim var_Count as oG2antt = topparent:CONTROL_ACTIVEX1.activex var_Count = oG2antt.Columns.Count |
| 241 |
How can I change the font for all cells in the entire column
Dim f as P Dim oG2antt as P Dim var_ConditionalFormat as P oG2antt = topparent:CONTROL_ACTIVEX1.activex f = OLE.Create("StdFont") f.Name = "Tahoma" f.Size = 12 var_ConditionalFormat = oG2antt.ConditionalFormats.Add("1") var_ConditionalFormat.Font = f var_ConditionalFormat.ApplyTo = 0 oG2antt.Columns.Add("Column") oG2antt.Items.AddItem(0) oG2antt.Items.AddItem(1) |
| 240 |
How can I change the background color for all cells in the column
Dim oG2antt as P Dim var_ConditionalFormat as P oG2antt = topparent:CONTROL_ACTIVEX1.activex var_ConditionalFormat = oG2antt.ConditionalFormats.Add("1") var_ConditionalFormat.BackColor = 255 var_ConditionalFormat.ApplyTo = 0 oG2antt.Columns.Add("Column") oG2antt.Items.AddItem(0) oG2antt.Items.AddItem(1) |
| 239 |
How can I change the foreground color for all cells in the column
Dim oG2antt as P Dim var_ConditionalFormat as P oG2antt = topparent:CONTROL_ACTIVEX1.activex var_ConditionalFormat = oG2antt.ConditionalFormats.Add("1") var_ConditionalFormat.ForeColor = 255 var_ConditionalFormat.ApplyTo = 0 oG2antt.Columns.Add("Column") oG2antt.Items.AddItem(0) oG2antt.Items.AddItem(1) |
| 238 |
How can I show as strikeout all cells in the column
Dim oG2antt as P Dim var_ConditionalFormat as P oG2antt = topparent:CONTROL_ACTIVEX1.activex var_ConditionalFormat = oG2antt.ConditionalFormats.Add("1") var_ConditionalFormat.StrikeOut = .t. var_ConditionalFormat.ApplyTo = 0 oG2antt.Columns.Add("Column") oG2antt.Items.AddItem(0) oG2antt.Items.AddItem(1) |
| 237 |
How can I underline all cells in the column
Dim oG2antt as P Dim var_ConditionalFormat as P oG2antt = topparent:CONTROL_ACTIVEX1.activex var_ConditionalFormat = oG2antt.ConditionalFormats.Add("1") var_ConditionalFormat.Underline = .t. var_ConditionalFormat.ApplyTo = 0 oG2antt.Columns.Add("Column") oG2antt.Items.AddItem(0) oG2antt.Items.AddItem(1) |
| 236 |
How can I show in italic all data in the column
Dim oG2antt as P Dim var_ConditionalFormat as P oG2antt = topparent:CONTROL_ACTIVEX1.activex var_ConditionalFormat = oG2antt.ConditionalFormats.Add("1") var_ConditionalFormat.Italic = .t. var_ConditionalFormat.ApplyTo = 0 oG2antt.Columns.Add("Column") oG2antt.Items.AddItem(0) oG2antt.Items.AddItem(1) |
| 235 |
How can I bold the entire column
Dim oG2antt as P Dim var_ConditionalFormat as P oG2antt = topparent:CONTROL_ACTIVEX1.activex var_ConditionalFormat = oG2antt.ConditionalFormats.Add("1") var_ConditionalFormat.Bold = .t. var_ConditionalFormat.ApplyTo = 0 oG2antt.Columns.Add("Column") oG2antt.Items.AddItem(0) oG2antt.Items.AddItem(1) |
| 234 |
How can I display a computed column and highlight some values that are negative or less than a value
Dim oG2antt as P Dim var_Column as local Dim var_ConditionalFormat as P Dim var_Items as P Dim var_Items1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("A") oG2antt.Columns.Add("B") ' oG2antt.Columns.Add("(A+B)*1.19").ComputedField = "(dbl(%0) + dbl(%1)) * 1.19" var_Column = oG2antt.Columns.Add("(A+B)*1.19") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.ComputedField = `(dbl(%0) + dbl(%1)) * 1.19`" var_Items = oG2antt.Items ' var_Items.CellValue(var_Items.AddItem(1),1) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(AddItem(1),1) = 2" var_Items1 = oG2antt.Items ' var_Items1.CellValue(var_Items1.AddItem(10),1) = 20 oG2antt.TemplateDef = "dim var_Items1" oG2antt.TemplateDef = var_Items1 oG2antt.Template = "var_Items1.CellValue(AddItem(10),1) = 20" var_ConditionalFormat = oG2antt.ConditionalFormats.Add("dbl(%2) > 10") var_ConditionalFormat.Bold = .t. var_ConditionalFormat.ForeColor = 255 var_ConditionalFormat.ApplyTo = 2 '2 + |
| 233 |
Can I display a computed column so it displays the VAT, or SUM
Dim oG2antt as P Dim var_Column as local Dim var_Items as P Dim var_Items1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("A") oG2antt.Columns.Add("B") ' oG2antt.Columns.Add("(A+B)*1.19").ComputedField = "(dbl(%0) + dbl(%1)) * 1.19" var_Column = oG2antt.Columns.Add("(A+B)*1.19") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.ComputedField = `(dbl(%0) + dbl(%1)) * 1.19`" var_Items = oG2antt.Items ' var_Items.CellValue(var_Items.AddItem(1),1) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(AddItem(1),1) = 2" var_Items1 = oG2antt.Items ' var_Items1.CellValue(var_Items1.AddItem(10),1) = 20 oG2antt.TemplateDef = "dim var_Items1" oG2antt.TemplateDef = var_Items1 oG2antt.Template = "var_Items1.CellValue(AddItem(10),1) = 20" |
| 232 |
How can I show a column that adds values in the cells
Dim oG2antt as P Dim var_Column as local Dim var_Items as P Dim var_Items1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("A") oG2antt.Columns.Add("B") ' oG2antt.Columns.Add("A+B").ComputedField = "dbl(%0) + dbl(%1)" var_Column = oG2antt.Columns.Add("A+B") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.ComputedField = `dbl(%0) + dbl(%1)`" var_Items = oG2antt.Items ' var_Items.CellValue(var_Items.AddItem(1),1) = 2 oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(AddItem(1),1) = 2" var_Items1 = oG2antt.Items ' var_Items1.CellValue(var_Items1.AddItem(10),1) = 20 oG2antt.TemplateDef = "dim var_Items1" oG2antt.TemplateDef = var_Items1 oG2antt.Template = "var_Items1.CellValue(AddItem(10),1) = 20" |
| 231 |
Is there any function to filter the control's data as I type, so the items being displayed include the typed characters
Dim oG2antt as P Dim var_Column as P oG2antt = topparent:CONTROL_ACTIVEX1.activex var_Column = oG2antt.Columns.Add("Filter") var_Column.FilterOnType = .t. var_Column.DisplayFilterButton = .t. var_Column.AutoSearch = 1 oG2antt.Items.AddItem("Canada") oG2antt.Items.AddItem("USA") |
| 230 |
Is there any function to filter the control's data as I type, something like filter on type
Dim oG2antt as P Dim var_Column as P oG2antt = topparent:CONTROL_ACTIVEX1.activex var_Column = oG2antt.Columns.Add("Filter") var_Column.FilterOnType = .t. var_Column.DisplayFilterButton = .t. oG2antt.Items.AddItem("Canada") oG2antt.Items.AddItem("USA") |
| 229 |
How can I programmatically filter a column
Dim oG2antt as P Dim var_Column as P oG2antt = topparent:CONTROL_ACTIVEX1.activex var_Column = oG2antt.Columns.Add("Filter") var_Column.DisplayFilterButton = .t. var_Column.FilterType = 2 oG2antt.Items.AddItem() oG2antt.Items.AddItem("not empty") oG2antt.ApplyFilter() |
| 228 |
How can I show or display the control's filter
Dim oG2antt as P Dim var_Column as local oG2antt = topparent:CONTROL_ACTIVEX1.activex ' oG2antt.Columns.Add("Filter").DisplayFilterButton = .t. var_Column = oG2antt.Columns.Add("Filter") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.DisplayFilterButton = True" |
| 227 |
How can I customize the items being displayed in the drop down filter window
Dim oG2antt as P Dim var_Column as P oG2antt = topparent:CONTROL_ACTIVEX1.activex var_Column = oG2antt.Columns.Add("Custom Filter") var_Column.DisplayFilterButton = .t. var_Column.DisplayFilterPattern = .f. var_Column.CustomFilter = "Excel Spreadsheets (*.xls )||*.xls|||Word Documents||*.doc|||Powerpoint Presentations||*.pps|||Text Documents (*.log,*.txt)||*.txt|*.log" var_Column.FilterType = 3 var_Column.Filter = "*.xls" oG2antt.Items.AddItem("excel.xls") oG2antt.Items.AddItem("word.doc") oG2antt.Items.AddItem("pp.pps") oG2antt.Items.AddItem("text.txt") oG2antt.ApplyFilter() |
| 226 |
How can I change the order or the position of the columns in the sort bar
Dim oG2antt as P Dim var_Column as local Dim var_Column1 as local oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.SortBarVisible = .t. oG2antt.SortBarColumnWidth = 48 ' oG2antt.Columns.Add("C1").SortOrder = 1 var_Column = oG2antt.Columns.Add("C1") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.SortOrder = 1" ' oG2antt.Columns.Add("C2").SortOrder = 2 var_Column1 = oG2antt.Columns.Add("C2") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.SortOrder = 2" oG2antt.Columns.Item("C2").SortPosition = 0 |
| 225 |
How do I arrange my columns on multiple levels
Dim oG2antt as P Dim var_Column as local Dim var_Column1 as local Dim var_Column2 as local Dim var_Column3 as local Dim var_Column4 as local Dim var_Column5 as local Dim var_Column6 as local Dim var_Column7 as local Dim var_Column8 as local oG2antt = topparent:CONTROL_ACTIVEX1.activex ' oG2antt.Columns.Add("S").Width = 32 var_Column = oG2antt.Columns.Add("S") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Width = 32" ' oG2antt.Columns.Add("Level 2").LevelKey = 1 var_Column1 = oG2antt.Columns.Add("Level 2") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.LevelKey = 1" ' oG2antt.Columns.Add("Level 3").LevelKey = 1 var_Column2 = oG2antt.Columns.Add("Level 3") oG2antt.TemplateDef = "dim var_Column2" oG2antt.TemplateDef = var_Column2 oG2antt.Template = "var_Column2.LevelKey = 1" ' oG2antt.Columns.Add("Level 4").LevelKey = 1 var_Column3 = oG2antt.Columns.Add("Level 4") oG2antt.TemplateDef = "dim var_Column3" oG2antt.TemplateDef = var_Column3 oG2antt.Template = "var_Column3.LevelKey = 1" ' oG2antt.Columns.Add("Level 1").LevelKey = "2" var_Column4 = oG2antt.Columns.Add("Level 1") oG2antt.TemplateDef = "dim var_Column4" oG2antt.TemplateDef = var_Column4 oG2antt.Template = "var_Column4.LevelKey = `2`" ' oG2antt.Columns.Add("Level 2").LevelKey = "2" var_Column5 = oG2antt.Columns.Add("Level 2") oG2antt.TemplateDef = "dim var_Column5" oG2antt.TemplateDef = var_Column5 oG2antt.Template = "var_Column5.LevelKey = `2`" ' oG2antt.Columns.Add("Level 3").LevelKey = "2" var_Column6 = oG2antt.Columns.Add("Level 3") oG2antt.TemplateDef = "dim var_Column6" oG2antt.TemplateDef = var_Column6 oG2antt.Template = "var_Column6.LevelKey = `2`" ' oG2antt.Columns.Add("Level 4").LevelKey = "2" var_Column7 = oG2antt.Columns.Add("Level 4") oG2antt.TemplateDef = "dim var_Column7" oG2antt.TemplateDef = var_Column7 oG2antt.Template = "var_Column7.LevelKey = `2`" ' oG2antt.Columns.Add("E").Width = 32 var_Column8 = oG2antt.Columns.Add("E") oG2antt.TemplateDef = "dim var_Column8" oG2antt.TemplateDef = var_Column8 oG2antt.Template = "var_Column8.Width = 32" |
| 224 |
How do I arrange my columns on multiple lines
Dim oG2antt as P Dim var_Column as local oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.HeaderHeight = 32 ' oG2antt.Columns.Add("").HTMLCaption = "Line 1<br>Line 2" var_Column = oG2antt.Columns.Add("") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.HTMLCaption = `Line 1<br>Line 2`" |
| 223 |
How can I display all cells using HTML format
Dim oG2antt as P Dim var_Column as local oG2antt = topparent:CONTROL_ACTIVEX1.activex ' oG2antt.Columns.Add("HTML").Def(17) = 1 var_Column = oG2antt.Columns.Add("HTML") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Def(17) = 1" oG2antt.Items.AddItem("<font ;12>T</font>his <b>is</b> an <a>html</a> <font Tahoma><fgcolor=FF0000>text</fgcolor></font>.") |
| 222 |
How can I display all cells using multiple lines
Dim oG2antt as P Dim var_Column as local Dim var_Column1 as local Dim var_Items as P oG2antt = topparent:CONTROL_ACTIVEX1.activex ' oG2antt.Columns.Add("MultipleLine").Def(16) = .f. var_Column = oG2antt.Columns.Add("MultipleLine") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Def(16) = False" ' oG2antt.Columns.Add("SingleLine").Def(16) = .t. var_Column1 = oG2antt.Columns.Add("SingleLine") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Def(16) = True" var_Items = oG2antt.Items ' var_Items.CellValue(var_Items.AddItem("This is a bit of long text that should break the line"),1) = "this is a bit of long text that's displayed on a single line" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(AddItem(`This is a bit of long text that should break the line`),1) = `this is a bit of long text that's displayed on a single line`" |
| 221 |
How do change the vertical alignment for all cells in the column
Dim oG2antt as P Dim var_Column as local Dim var_Column1 as local Dim var_Items as P Dim var_Items1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex ' oG2antt.Columns.Add("MultipleLine").Def(16) = .f. var_Column = oG2antt.Columns.Add("MultipleLine") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Def(16) = False" ' oG2antt.Columns.Add("VAlign").Def(6) = 2 var_Column1 = oG2antt.Columns.Add("VAlign") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Def(6) = 2" var_Items = oG2antt.Items ' var_Items.CellValue(var_Items.AddItem("This is a bit of long text that should break the line"),1) = "bottom" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(AddItem(`This is a bit of long text that should break the line`),1) = `bottom`" var_Items1 = oG2antt.Items ' var_Items1.CellValue(var_Items1.AddItem("This is a bit of long text that should break the line"),1) = "bottom" oG2antt.TemplateDef = "dim var_Items1" oG2antt.TemplateDef = var_Items1 oG2antt.Template = "var_Items1.CellValue(AddItem(`This is a bit of long text that should break the line`),1) = `bottom`" |
| 220 |
How do change the foreground color for all cells in the column
Dim oG2antt as P Dim var_Column as local oG2antt = topparent:CONTROL_ACTIVEX1.activex ' oG2antt.Columns.Add("ForeColor").Def(5) = 255 var_Column = oG2antt.Columns.Add("ForeColor") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Def(5) = 255" oG2antt.Items.AddItem(0) oG2antt.Items.AddItem(1) |
| 219 |
How do change the background color for all cells in the column
Dim oG2antt as P Dim var_Column as local oG2antt = topparent:CONTROL_ACTIVEX1.activex ' oG2antt.Columns.Add("BackColor").Def(4) = 255 var_Column = oG2antt.Columns.Add("BackColor") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Def(4) = 255" oG2antt.Items.AddItem(0) oG2antt.Items.AddItem(1) |
| 218 |
How do I show buttons for all cells in the column
Dim oG2antt as P Dim var_Column as P oG2antt = topparent:CONTROL_ACTIVEX1.activex var_Column = oG2antt.Columns.Add("Button") ' var_Column.Def(2) = .t. oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Def(2) = True" ' var_Column.Def(3) = .t. oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Def(3) = True" oG2antt.Items.AddItem(" Button 1 ") oG2antt.Items.AddItem(" Button 2 ") |
| 217 |
How do I show buttons for all cells in the column
Dim oG2antt as P Dim var_Column as local oG2antt = topparent:CONTROL_ACTIVEX1.activex ' oG2antt.Columns.Add("Button").Def(2) = .t. var_Column = oG2antt.Columns.Add("Button") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Def(2) = True" oG2antt.Items.AddItem(0) oG2antt.Items.AddItem(1) |
| 216 |
How do I display radio buttons for all cells in the column
Dim oG2antt as P Dim var_Column as local oG2antt = topparent:CONTROL_ACTIVEX1.activex ' oG2antt.Columns.Add("Radio").Def(1) = .t. var_Column = oG2antt.Columns.Add("Radio") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Def(1) = True" oG2antt.Items.AddItem(0) oG2antt.Items.AddItem(1) |
| 215 |
How do I display checkboxes for all cells in the column
Dim oG2antt as P Dim var_Column as local oG2antt = topparent:CONTROL_ACTIVEX1.activex ' oG2antt.Columns.Add("Check").Def(0) = .t. var_Column = oG2antt.Columns.Add("Check") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Def(0) = True" oG2antt.Items.AddItem(0) oG2antt.Items.AddItem(1) |
| 214 |
How can I display a tooltip when the cursor hovers the column
Dim oG2antt as P Dim var_Column as local oG2antt = topparent:CONTROL_ACTIVEX1.activex ' oG2antt.Columns.Add("tooltip").ToolTip = "This is a bit of text that is shown when user hovers the column." var_Column = oG2antt.Columns.Add("tooltip") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.ToolTip = `This is a bit of text that is shown when user hovers the column.`" |
| 213 |
Is there any function to assign a key to a column instead using its name or capion
Dim oG2antt as P Dim var_Column as local Dim var_Column1 as local oG2antt = topparent:CONTROL_ACTIVEX1.activex ' oG2antt.Columns.Add("Data").Key = "DKey" var_Column = oG2antt.Columns.Add("Data") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Key = `DKey`" ' oG2antt.Columns.Item("DKey").Caption = "new caption" var_Column1 = oG2antt.Columns.Item("DKey") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.Caption = `new caption`" |
| 212 |
Is there any function to assign any extra data to a column
Dim oG2antt as P Dim var_Column as local oG2antt = topparent:CONTROL_ACTIVEX1.activex ' oG2antt.Columns.Add("Data").Data = "your extra data" var_Column = oG2antt.Columns.Add("Data") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Data = `your extra data`" |
| 211 |
By default, the column gets sorted descending, when I first click its header. How can I change so the column gets sorted ascending when the user first clicks the column's header
Dim oG2antt as P Dim var_Column as local oG2antt = topparent:CONTROL_ACTIVEX1.activex ' oG2antt.Columns.Add("Sort").DefaultSortOrder = .t. var_Column = oG2antt.Columns.Add("Sort") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.DefaultSortOrder = True" |
| 210 |
How can I specify the maximum width for the column, if I use WidthAutoResize property
Dim oG2antt as P Dim var_Column as P oG2antt = topparent:CONTROL_ACTIVEX1.activex var_Column = oG2antt.Columns.Add("Auto") var_Column.WidthAutoResize = .t. var_Column.MinWidthAutoResize = 32 var_Column.MaxWidthAutoResize = 128 oG2antt.Items.AddItem(0) oG2antt.Items.AddItem(1) |
| 209 |
How can I specify the minimum width for the column, if I use WidthAutoResize property
Dim oG2antt as P Dim var_Column as P oG2antt = topparent:CONTROL_ACTIVEX1.activex var_Column = oG2antt.Columns.Add("Auto") var_Column.WidthAutoResize = .t. var_Column.MinWidthAutoResize = 32 oG2antt.Items.AddItem(0) oG2antt.Items.AddItem(1) |
| 208 |
Is there any option to resize the column based on its data, captions
Dim oG2antt as P Dim var_Column as local oG2antt = topparent:CONTROL_ACTIVEX1.activex ' oG2antt.Columns.Add("A").WidthAutoResize = .t. var_Column = oG2antt.Columns.Add("A") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.WidthAutoResize = True" oG2antt.Items.AddItem(0) oG2antt.Items.AddItem(1) |
| 207 |
How can I align the icon in the column's header in the center
Dim oG2antt as P Dim var_Column as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") var_Column = oG2antt.Columns.Add("") var_Column.HeaderImage = 1 var_Column.HeaderImageAlignment = 1 |
| 206 |
How do I align the icon in the column's header to the right
Dim oG2antt as P Dim var_Column as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") var_Column = oG2antt.Columns.Add("ColumnName") var_Column.HeaderImage = 1 var_Column.HeaderImageAlignment = 2 |
| 205 |
How do I show or hide the sorting icons, but still need sorting
Dim oG2antt as P Dim var_Column as local oG2antt = topparent:CONTROL_ACTIVEX1.activex ' oG2antt.Columns.Add("Sorted").SortOrder = 1 var_Column = oG2antt.Columns.Add("Sorted") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.SortOrder = 1" oG2antt.Columns.Item(0).DisplaySortIcon = .f. |
| 204 |
How do I enable or disable the entire column
Dim oG2antt as P Dim var_Column as local Dim var_Items as P Dim var_Items1 as P oG2antt = topparent:CONTROL_ACTIVEX1.activex oG2antt.Columns.Add("C1") ' oG2antt.Columns.Add("Disabled").Enabled = .f. var_Column = oG2antt.Columns.Add("Disabled") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.Enabled = False" var_Items = oG2antt.Items ' var_Items.CellValue(var_Items.AddItem(0),1) = "0.1" oG2antt.TemplateDef = "dim var_Items" oG2antt.TemplateDef = var_Items oG2antt.Template = "var_Items.CellValue(AddItem(0),1) = `0.1`" var_Items1 = oG2antt.Items ' var_Items1.CellValue(var_Items1.AddItem(1),1) = "1.1" oG2antt.TemplateDef = "dim var_Items1" oG2antt.TemplateDef = var_Items1 oG2antt.Template = "var_Items1.CellValue(AddItem(1),1) = `1.1`" |
| 203 |
How do I disable drag and drop columns
Dim oG2antt as P Dim var_Column as local Dim var_Column1 as local oG2antt = topparent:CONTROL_ACTIVEX1.activex ' oG2antt.Columns.Add("C1").AllowDragging = .f. var_Column = oG2antt.Columns.Add("C1") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.AllowDragging = False" ' oG2antt.Columns.Add("C2").AllowDragging = .f. var_Column1 = oG2antt.Columns.Add("C2") oG2antt.TemplateDef = "dim var_Column1" oG2antt.TemplateDef = var_Column1 oG2antt.Template = "var_Column1.AllowDragging = False" |
| 202 |
How do I disable resizing a column at runtime
Dim oG2antt as P Dim var_Column as local oG2antt = topparent:CONTROL_ACTIVEX1.activex ' oG2antt.Columns.Add("Unsizable").AllowSizing = .f. var_Column = oG2antt.Columns.Add("Unsizable") oG2antt.TemplateDef = "dim var_Column" oG2antt.TemplateDef = var_Column oG2antt.Template = "var_Column.AllowSizing = False" oG2antt.Columns.Add("C2") oG2antt.Columns.Add("C3") oG2antt.Columns.Add("C4") |
| 201 |
How can I align the column to the right, and its caption too
Dim oG2antt as P Dim var_Column as P oG2antt = topparent:CONTROL_ACTIVEX1.activex var_Column = oG2antt.Columns.Add("Column") var_Column.Alignment = 2 var_Column.HeaderAlignment = 2 oG2antt.Items.AddItem(0) oG2antt.Items.AddItem(1) |
